USE mesx;

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept`
(
    `dept_id`     int(20)   NOT NULL AUTO_INCREMENT,
    `name`        varchar(50)        DEFAULT NULL,
    `sort`        int(11)   NOT NULL DEFAULT '0' COMMENT '排序',
    `create_time` timestamp NULL     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NULL     DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `del_flag`    char(1)            DEFAULT '0',
    `parent_id`   int(11)            DEFAULT NULL,
    `tenant_id`   int(11)            DEFAULT NULL,
    PRIMARY KEY (`dept_id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 9
  DEFAULT CHARSET = utf8mb4 COMMENT ='部门管理';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept`
VALUES (1, '山东', 1, '2018-01-22 19:00:23', '2019-05-18 14:56:06', '0', 0, 1);
INSERT INTO `sys_dept`
VALUES (2, '沙县国际', 2, '2018-01-22 19:00:38', '2019-05-18 14:12:07', '0', 0, 1);
INSERT INTO `sys_dept`
VALUES (3, '潍坊', 3, '2018-01-22 19:00:44', '2019-05-18 14:56:11', '0', 1, 1);
INSERT INTO `sys_dept`
VALUES (4, '高新', 4, '2018-01-22 19:00:52', '2019-05-18 14:56:09', '0', 3, 1);
INSERT INTO `sys_dept`
VALUES (5, '院校', 5, '2018-01-22 19:00:57', '2019-05-18 14:56:13', '0', 4, 1);
INSERT INTO `sys_dept`
VALUES (6, '潍院', 6, '2018-01-22 19:01:06', '2019-05-18 14:56:16', '1', 5, 1);
INSERT INTO `sys_dept`
VALUES (7, '山东沙县', 7, '2018-01-22 19:01:57', '2019-05-18 14:12:17', '0', 2, 1);
INSERT INTO `sys_dept`
VALUES (8, '潍坊沙县', 8, '2018-01-22 19:02:03', '2019-05-18 14:12:19', '0', 7, 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_dept_relation
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept_relation`;
CREATE TABLE `sys_dept_relation`
(
    `ancestor`   int(11) NOT NULL COMMENT '祖先节点',
    `descendant` int(11) NOT NULL COMMENT '后代节点',
    PRIMARY KEY (`ancestor`, `descendant`) USING BTREE,
    KEY `idx1` (`ancestor`) USING BTREE,
    KEY `idx2` (`descendant`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='部门关系表';

-- ----------------------------
-- Records of sys_dept_relation
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept_relation`
VALUES (1, 1);
INSERT INTO `sys_dept_relation`
VALUES (1, 3);
INSERT INTO `sys_dept_relation`
VALUES (1, 4);
INSERT INTO `sys_dept_relation`
VALUES (1, 5);
INSERT INTO `sys_dept_relation`
VALUES (2, 2);
INSERT INTO `sys_dept_relation`
VALUES (2, 7);
INSERT INTO `sys_dept_relation`
VALUES (2, 8);
INSERT INTO `sys_dept_relation`
VALUES (2, 11);
INSERT INTO `sys_dept_relation`
VALUES (2, 12);
INSERT INTO `sys_dept_relation`
VALUES (3, 3);
INSERT INTO `sys_dept_relation`
VALUES (3, 4);
INSERT INTO `sys_dept_relation`
VALUES (3, 5);
INSERT INTO `sys_dept_relation`
VALUES (4, 4);
INSERT INTO `sys_dept_relation`
VALUES (4, 5);
INSERT INTO `sys_dept_relation`
VALUES (5, 5);
INSERT INTO `sys_dept_relation`
VALUES (7, 7);
INSERT INTO `sys_dept_relation`
VALUES (7, 8);
INSERT INTO `sys_dept_relation`
VALUES (7, 11);
INSERT INTO `sys_dept_relation`
VALUES (7, 12);
INSERT INTO `sys_dept_relation`
VALUES (8, 8);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict`;
CREATE TABLE `sys_dict`
(
    `id`          int(64)   NOT NULL AUTO_INCREMENT COMMENT '编号',
    `type`        varchar(100)       DEFAULT NULL,
    `description` varchar(100)       DEFAULT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remarks`     varchar(255)       DEFAULT NULL,
    `system`      char(1)            DEFAULT '0',
    `del_flag`    char(1)            DEFAULT '0',
    `tenant_id`   int(11)   NOT NULL DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 32
  DEFAULT CHARSET = utf8mb4 COMMENT ='字典表';

-- ----------------------------
-- Records of sys_dict
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict`
VALUES (1, 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (2, 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (3, 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (4, 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (5, 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (6, 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (7, 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (8, 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (9, 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (10, 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (11, 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (12, 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (13, 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', 1);
INSERT INTO `sys_dict`
VALUES (14, 'channel_status', '支付渠道状态', '2019-05-30 16:14:43', '2019-05-30 16:14:43', '支付渠道状态（0-正常，1-冻结）', '0', '0', 1);
INSERT INTO `sys_dict`
VALUES (15, 'channel_id', '渠道编码ID', '2019-05-30 18:59:12', '2019-05-30 18:59:12', '不同的支付方式', '0', '0', 1);
INSERT INTO `sys_dict`
VALUES (16, 'order_status', '订单状态', '2019-06-27 08:17:40', '2019-06-27 08:17:40', '支付订单状态', '0', '0', 1);
INSERT INTO `sys_dict`
VALUES (17, 'grant_types', '授权类型', '2019-08-13 07:34:10', '2019-08-13 07:34:10', NULL, '0', '0', 1);
INSERT INTO `sys_dict`
VALUES (18, 'log_type', '日志类型', '2019-03-19 11:06:44', '2019-03-19 11:06:44', '异常、正常', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (19, 'social_type', '社交登录', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '微信、QQ', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (20, 'leave_status', '请假状态', '2019-03-19 11:09:44', '2019-03-19 11:09:44', '未提交、审批中、完成、驳回', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (21, 'job_type', '定时任务类型', '2019-03-19 11:22:21', '2019-03-19 11:22:21', 'quartz', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (22, 'job_status', '定时任务状态', '2019-03-19 11:24:57', '2019-03-19 11:24:57', '发布状态、运行状态', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (23, 'job_execute_status', '定时任务执行状态', '2019-03-19 11:26:15', '2019-03-19 11:26:15', '正常、异常', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (24, 'misfire_policy', '定时任务错失执行策略', '2019-03-19 11:27:19', '2019-03-19 11:27:19', '周期', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (25, 'gender', '性别', '2019-03-27 13:44:06', '2019-03-27 13:44:06', '微信用户性别', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (26, 'subscribe', '订阅状态', '2019-03-27 13:48:33', '2019-03-27 13:48:33', '公众号订阅状态', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (27, 'response_type', '回复', '2019-03-28 21:29:21', '2019-03-28 21:29:21', '微信消息是否已回复', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (28, 'param_type', '参数配置', '2019-04-29 18:20:47', '2019-04-29 18:20:47', '检索、原文、报表、安全、文档、消息、其他', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (29, 'tenant_status_type', '租户状态', '2019-05-15 16:31:08', '2019-05-15 16:31:08', '租户状态', '1', '0', 2);
INSERT INTO `sys_dict`
VALUES (30, 'dict_type', '字典类型', '2019-05-16 14:16:20', '2019-05-16 14:20:16', '系统类不能修改', '1', '0', 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_dict_item
-- ----------------------------
DROP TABLE IF EXISTS `sys_dict_item`;
CREATE TABLE `sys_dict_item`
(
    `id`          int(64)   NOT NULL AUTO_INCREMENT COMMENT '编号',
    `dict_id`     int(11)   NOT NULL,
    `value`       varchar(100)       DEFAULT NULL,
    `label`       varchar(100)       DEFAULT NULL,
    `type`        varchar(100)       DEFAULT NULL,
    `description` varchar(100)       DEFAULT NULL,
    `sort`        int(10)   NOT NULL DEFAULT '0' COMMENT '排序（升序）',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remarks`     varchar(255)       DEFAULT NULL,
    `del_flag`    char(1)            DEFAULT '0',
    `tenant_id`   int(11)   NOT NULL DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `sys_dict_value` (`value`) USING BTREE,
    KEY `sys_dict_label` (`label`) USING BTREE,
    KEY `sys_dict_del_flag` (`del_flag`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 96
  DEFAULT CHARSET = utf8mb4 COMMENT ='字典项';

-- ----------------------------
-- Records of sys_dict_item
-- ----------------------------
BEGIN;
INSERT INTO `sys_dict_item`
VALUES (1, 1, '9', '异常', 'log_type', '日志异常', 1, '2019-03-19 11:08:59', '2019-03-25 12:49:13', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (2, 1, '0', '正常', 'log_type', '日志正常', 0, '2019-03-19 11:09:17', '2019-03-25 12:49:18', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (3, 2, 'WX', '微信', 'social_type', '微信登录', 0, '2019-03-19 11:10:02', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (4, 2, 'QQ', 'QQ', 'social_type', 'QQ登录', 1, '2019-03-19 11:10:14', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (5, 3, '0', '未提交', 'leave_status', '未提交', 0, '2019-03-19 11:18:34', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (6, 3, '1', '审批中', 'leave_status', '审批中', 1, '2019-03-19 11:18:45', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (7, 3, '2', '完成', 'leave_status', '完成', 2, '2019-03-19 11:19:02', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (8, 3, '9', '驳回', 'leave_status', '驳回', 9, '2019-03-19 11:19:20', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (9, 4, '1', 'java类', 'job_type', 'java类', 1, '2019-03-19 11:22:37', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (10, 4, '2', 'spring bean', 'job_type', 'spring bean容器实例', 2, '2019-03-19 11:23:05', '2019-03-25 12:49:36', '',
        '0', 1);
INSERT INTO `sys_dict_item`
VALUES (11, 4, '9', '其他', 'job_type', '其他类型', 9, '2019-03-19 11:23:31', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (12, 4, '3', 'Rest 调用', 'job_type', 'Rest 调用', 3, '2019-03-19 11:23:57', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (13, 4, '4', 'jar', 'job_type', 'jar类型', 4, '2019-03-19 11:24:20', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (14, 5, '1', '未发布', 'job_status', '未发布', 1, '2019-03-19 11:25:18', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (15, 5, '2', '运行中', 'job_status', '运行中', 2, '2019-03-19 11:25:31', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (16, 5, '3', '暂停', 'job_status', '暂停', 3, '2019-03-19 11:25:42', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (17, 6, '0', '正常', 'job_execute_status', '正常', 0, '2019-03-19 11:26:27', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (18, 6, '1', '异常', 'job_execute_status', '异常', 1, '2019-03-19 11:26:41', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (19, 7, '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', 1, '2019-03-19 11:27:45', '2019-03-25 12:49:36', '', '0',
        1);
INSERT INTO `sys_dict_item`
VALUES (20, 7, '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', 2, '2019-03-19 11:27:57', '2019-03-25 12:49:36', '', '0',
        1);
INSERT INTO `sys_dict_item`
VALUES (21, 7, '3', '下周期执行', 'misfire_policy', '下周期执行', 3, '2019-03-19 11:28:08', '2019-03-25 12:49:36', '', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (22, 8, '1', '男', 'gender', '微信-男', 0, '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (23, 8, '2', '女', 'gender', '女-微信', 1, '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (24, 8, '0', '未知', 'gender', 'x性别未知', 3, '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (25, 9, '0', '未关注', 'subscribe', '公众号-未关注', 0, '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (26, 9, '1', '已关注', 'subscribe', '公众号-已关注', 1, '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (27, 10, '0', '未回复', 'response_type', '微信消息-未回复', 0, '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复',
        '0', 1);
INSERT INTO `sys_dict_item`
VALUES (28, 10, '1', '已回复', 'response_type', '微信消息-已回复', 1, '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复',
        '0', 1);
INSERT INTO `sys_dict_item`
VALUES (29, 11, '1', '检索', 'param_type', '检索', 0, '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (30, 11, '2', '原文', 'param_type', '原文', 0, '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (31, 11, '3', '报表', 'param_type', '报表', 0, '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (32, 11, '4', '安全', 'param_type', '安全', 0, '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (33, 11, '5', '文档', 'param_type', '文档', 0, '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (34, 11, '6', '消息', 'param_type', '消息', 0, '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (35, 11, '9', '其他', 'param_type', '其他', 0, '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (36, 11, '0', '默认', 'param_type', '默认', 0, '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (37, 12, '0', '正常', 'status_type', '状态正常', 0, '2019-05-15 16:31:34', '2019-05-16 22:30:46', '状态正常', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (38, 12, '9', '冻结', 'status_type', '状态冻结', 1, '2019-05-15 16:31:56', '2019-05-16 22:30:50', '状态冻结', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (39, 13, '1', '系统类', 'dict_type', '系统类字典', 0, '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (40, 13, '0', '业务类', 'dict_type', '业务类字典', 0, '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (41, 14, '0', '正常', 'channel_status', '支付渠道状态正常', 0, '2019-05-30 16:16:51', '2019-05-30 16:16:51', NULL, '0', 1);
INSERT INTO `sys_dict_item`
VALUES (42, 14, '1', '冻结', 'channel_status', '支付渠道冻结', 0, '2019-05-30 16:17:08', '2019-05-30 16:17:08', NULL, '0', 1);
INSERT INTO `sys_dict_item`
VALUES (43, 15, 'ALIPAY_WAP', '支付宝wap支付', 'channel_id', '支付宝扫码支付', 0, '2019-05-30 19:03:16', '2019-06-18 13:51:42',
        '支付宝wap支付', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (44, 15, 'WEIXIN_MP', '微信公众号支付', 'channel_id', '微信公众号支付', 1, '2019-05-30 19:08:08', '2019-06-18 13:51:53',
        '微信公众号支付', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (45, 16, '1', '支付成功', 'order_status', '支付成功', 1, '2019-06-27 08:18:26', '2019-06-27 08:18:26', '订单支付成功', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (46, 16, '2', '支付完成', 'order_status', '订单支付完成', 2, '2019-06-27 08:18:44', '2019-06-27 08:18:44', '订单支付完成', '0',
        1);
INSERT INTO `sys_dict_item`
VALUES (47, 16, '0', '待支付', 'order_status', '订单待支付', 0, '2019-06-27 08:19:02', '2019-06-27 08:19:02', '订单待支付', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (48, 16, '-1', '支付失败', 'order_status', '订单支付失败', 3, '2019-06-27 08:19:37', '2019-06-27 08:19:37', '订单支付失败', '0',
        1);
INSERT INTO `sys_dict_item`
VALUES (49, 2, 'GITEE', '码云', 'social_type', '码云', 2, '2019-06-28 09:59:12', '2019-06-28 09:59:12', '码云', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (50, 2, 'OSC', '开源中国', 'social_type', '开源中国登录', 0, '2019-06-28 10:04:32', '2019-06-28 10:04:32',
        'http://gitee.huaxiadaowei.com/#/authredirect', '0', 1);
INSERT INTO `sys_dict_item`
VALUES (51, 17, 'password', '密码模式', 'grant_types', '支持oauth密码模式', 0, '2019-08-13 07:35:28', '2019-08-13 07:35:28', NULL,
        '0', 1);
INSERT INTO `sys_dict_item`
VALUES (52, 17, 'authorization_code', '授权码模式', 'grant_types', 'oauth2 授权码模式', 1, '2019-08-13 07:36:07',
        '2019-08-13 07:36:07', NULL, '0', 1);
INSERT INTO `sys_dict_item`
VALUES (53, 17, 'client_credentials', '客户端模式', 'grant_types', 'oauth2 客户端模式', 2, '2019-08-13 07:36:30',
        '2019-08-13 07:36:30', NULL, '0', 1);
INSERT INTO `sys_dict_item`
VALUES (54, 17, 'refresh_token', '刷新模式', 'grant_types', 'oauth2 刷新token', 3, '2019-08-13 07:36:54',
        '2019-08-13 07:36:54', NULL, '0', 1);
INSERT INTO `sys_dict_item`
VALUES (55, 17, 'implicit', '简化模式', 'grant_types', 'oauth2 简化模式', 4, '2019-08-13 07:39:32', '2019-08-13 07:39:32', NULL,
        '0', 1);
INSERT INTO `sys_dict_item`
VALUES (56, 18, '9', '异常', 'log_type', '日志异常', 1, '2019-03-19 11:08:59', '2019-03-25 12:49:13', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (57, 18, '0', '正常', 'log_type', '日志正常', 0, '2019-03-19 11:09:17', '2019-03-25 12:49:18', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (58, 19, 'WX', '微信', 'social_type', '微信登录', 0, '2019-03-19 11:10:02', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (59, 19, 'QQ', 'QQ', 'social_type', 'QQ登录', 1, '2019-03-19 11:10:14', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (60, 19, 'GITEE', '码云', 'social_type', '码云', 2, '2019-06-28 09:59:12', '2019-06-28 09:59:12', '码云', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (61, 19, 'OSC', '开源中国', 'social_type', '开源中国登录', 0, '2019-06-28 10:04:32', '2019-06-28 10:04:32',
        'http://gitee.huaxiadaowei.com/#/authredirect', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (62, 20, '0', '未提交', 'leave_status', '未提交', 0, '2019-03-19 11:18:34', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (63, 20, '1', '审批中', 'leave_status', '审批中', 1, '2019-03-19 11:18:45', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (64, 20, '2', '完成', 'leave_status', '完成', 2, '2019-03-19 11:19:02', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (65, 20, '9', '驳回', 'leave_status', '驳回', 9, '2019-03-19 11:19:20', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (66, 21, '1', 'java类', 'job_type', 'java类', 1, '2019-03-19 11:22:37', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (67, 21, '2', 'spring bean', 'job_type', 'spring bean容器实例', 2, '2019-03-19 11:23:05', '2019-03-25 12:49:36',
        NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (68, 21, '9', '其他', 'job_type', '其他类型', 9, '2019-03-19 11:23:31', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (69, 21, '3', 'Rest 调用', 'job_type', 'Rest 调用', 3, '2019-03-19 11:23:57', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (70, 21, '4', 'jar', 'job_type', 'jar类型', 4, '2019-03-19 11:24:20', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (71, 22, '1', '未发布', 'job_status', '未发布', 1, '2019-03-19 11:25:18', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (72, 22, '2', '运行中', 'job_status', '运行中', 2, '2019-03-19 11:25:31', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (73, 22, '3', '暂停', 'job_status', '暂停', 3, '2019-03-19 11:25:42', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (74, 23, '0', '正常', 'job_execute_status', '正常', 0, '2019-03-19 11:26:27', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (75, 23, '1', '异常', 'job_execute_status', '异常', 1, '2019-03-19 11:26:41', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (76, 24, '1', '错失周期立即执行', 'misfire_policy', '错失周期立即执行', 1, '2019-03-19 11:27:45', '2019-03-25 12:49:36', NULL,
        '0', 2);
INSERT INTO `sys_dict_item`
VALUES (77, 24, '2', '错失周期执行一次', 'misfire_policy', '错失周期执行一次', 2, '2019-03-19 11:27:57', '2019-03-25 12:49:36', NULL,
        '0', 2);
INSERT INTO `sys_dict_item`
VALUES (78, 24, '3', '下周期执行', 'misfire_policy', '下周期执行', 3, '2019-03-19 11:28:08', '2019-03-25 12:49:36', NULL, '0', 2);
INSERT INTO `sys_dict_item`
VALUES (79, 25, '1', '男', 'gender', '微信-男', 0, '2019-03-27 13:45:13', '2019-03-27 13:45:13', '微信-男', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (80, 25, '2', '女', 'gender', '女-微信', 1, '2019-03-27 13:45:34', '2019-03-27 13:45:34', '女-微信', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (81, 25, '0', '未知', 'gender', 'x性别未知', 3, '2019-03-27 13:45:57', '2019-03-27 13:45:57', 'x性别未知', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (82, 26, '0', '未关注', 'subscribe', '公众号-未关注', 0, '2019-03-27 13:49:07', '2019-03-27 13:49:07', '公众号-未关注', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (83, 26, '1', '已关注', 'subscribe', '公众号-已关注', 1, '2019-03-27 13:49:26', '2019-03-27 13:49:26', '公众号-已关注', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (84, 27, '0', '未回复', 'response_type', '微信消息-未回复', 0, '2019-03-28 21:29:47', '2019-03-28 21:29:47', '微信消息-未回复',
        '0', 2);
INSERT INTO `sys_dict_item`
VALUES (85, 27, '1', '已回复', 'response_type', '微信消息-已回复', 1, '2019-03-28 21:30:08', '2019-03-28 21:30:08', '微信消息-已回复',
        '0', 2);
INSERT INTO `sys_dict_item`
VALUES (86, 28, '1', '检索', 'param_type', '检索', 0, '2019-04-29 18:22:17', '2019-04-29 18:22:17', '检索', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (87, 28, '2', '原文', 'param_type', '原文', 0, '2019-04-29 18:22:27', '2019-04-29 18:22:27', '原文', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (88, 28, '3', '报表', 'param_type', '报表', 0, '2019-04-29 18:22:36', '2019-04-29 18:22:36', '报表', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (89, 28, '4', '安全', 'param_type', '安全', 0, '2019-04-29 18:22:46', '2019-04-29 18:22:46', '安全', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (90, 28, '5', '文档', 'param_type', '文档', 0, '2019-04-29 18:22:56', '2019-04-29 18:22:56', '文档', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (91, 28, '6', '消息', 'param_type', '消息', 0, '2019-04-29 18:23:05', '2019-04-29 18:23:05', '消息', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (92, 28, '9', '其他', 'param_type', '其他', 0, '2019-04-29 18:23:16', '2019-04-29 18:23:16', '其他', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (93, 28, '0', '默认', 'param_type', '默认', 0, '2019-04-29 18:23:30', '2019-04-29 18:23:30', '默认', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (94, 30, '1', '系统类', 'dict_type', '系统类字典', 0, '2019-05-16 14:20:40', '2019-05-16 14:20:40', '不能修改删除', '0', 2);
INSERT INTO `sys_dict_item`
VALUES (95, 30, '0', '业务类', 'dict_type', '业务类字典', 0, '2019-05-16 14:20:59', '2019-05-16 14:20:59', '可以修改', '0', 2);
COMMIT;

-- ----------------------------
-- Table structure for sys_file
-- ----------------------------
DROP TABLE IF EXISTS `sys_file`;
CREATE TABLE `sys_file`
(
    `id`          bigint(32) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `file_name`   varchar(100) DEFAULT NULL,
    `bucket_name` varchar(200) DEFAULT NULL,
    `original`    varchar(100) DEFAULT NULL,
    `type`        varchar(50)  DEFAULT NULL,
    `file_size`   bigint(50)   DEFAULT NULL COMMENT '文件大小',
    `create_user` varchar(32)  DEFAULT NULL,
    `create_time` datetime     DEFAULT CURRENT_TIMESTAMP COMMENT '上传时间',
    `update_user` varchar(32)  DEFAULT NULL,
    `update_time` datetime     DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `del_flag`    char(1)      DEFAULT '0',
    `tenant_id`   int(11)      DEFAULT NULL COMMENT '所属租户',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='文件管理表';

-- ----------------------------
-- Table structure for sys_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_log`;
CREATE TABLE `sys_log`
(
    `id`          bigint(64) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `type`        char(1)       DEFAULT '0',
    `title`       varchar(255)  DEFAULT NULL,
    `service_id`  varchar(32)   DEFAULT NULL,
    `create_by`   varchar(64)   DEFAULT NULL,
    `create_time` datetime      DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime      DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `remote_addr` varchar(255)  DEFAULT NULL,
    `user_agent`  varchar(1000) DEFAULT NULL,
    `request_uri` varchar(255)  DEFAULT NULL,
    `method`      varchar(10)   DEFAULT NULL,
    `params`      text,
    `time`        mediumtext CHARACTER SET utf8 COMMENT '执行时间',
    `del_flag`    char(1)       DEFAULT '0',
    `exception`   text,
    `tenant_id`   int(11)       DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`id`) USING BTREE,
    KEY `sys_log_create_by` (`create_by`) USING BTREE,
    KEY `sys_log_request_uri` (`request_uri`) USING BTREE,
    KEY `sys_log_type` (`type`) USING BTREE,
    KEY `sys_log_create_date` (`create_time`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='日志表';

-- ----------------------------
-- Table structure for sys_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_menu`;
CREATE TABLE `sys_menu`
(
    `menu_id`     int(11)   NOT NULL AUTO_INCREMENT COMMENT '菜单ID',
    `name`        varchar(32)    DEFAULT NULL,
    `permission`  varchar(32)    DEFAULT NULL,
    `path`        varchar(128)   DEFAULT NULL,
    `parent_id`   int(11)        DEFAULT NULL COMMENT '父菜单ID',
    `icon`        varchar(32)    DEFAULT NULL,
    `sort`        int(11)        DEFAULT '1' COMMENT '排序值',
    `keep_alive`  char(1)        DEFAULT '0',
    `type`        char(1)        DEFAULT '0',
    `create_time` timestamp NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NULL DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `del_flag`    char(1)        DEFAULT '0',
    PRIMARY KEY (`menu_id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 10013
  DEFAULT CHARSET = utf8mb4 COMMENT ='菜单权限表';

-- ----------------------------
-- Records of sys_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_menu`
VALUES (1000, '权限管理', NULL, '/user', -1, 'icon-quanxianguanli', 0, '0', '0', '2018-09-28 08:29:53',
        '2018-09-28 08:53:01', '0');
INSERT INTO `sys_menu`
VALUES (1100, '用户管理', NULL, '/admin/user/index', 1000, 'icon-yonghuguanli', 1, '1', '0', '2017-11-02 22:24:37',
        '2019-06-24 14:36:36', '0');
INSERT INTO `sys_menu`
VALUES (1101, '用户新增', 'sys_user_add', NULL, 1100, NULL, NULL, '0', '1', '2017-11-08 09:52:09', '2018-09-28 09:06:34',
        '0');
INSERT INTO `sys_menu`
VALUES (1102, '用户修改', 'sys_user_edit', NULL, 1100, NULL, NULL, '0', '1', '2017-11-08 09:52:48', '2018-09-28 09:06:37',
        '0');
INSERT INTO `sys_menu`
VALUES (1103, '用户删除', 'sys_user_del', NULL, 1100, NULL, NULL, '0', '1', '2017-11-08 09:54:01', '2018-09-28 09:06:42',
        '0');
INSERT INTO `sys_menu`
VALUES (1200, '菜单管理', NULL, '/admin/menu/index', 1000, 'icon-caidanguanli', 2, '0', '0', '2017-11-08 09:57:27',
        '2019-06-24 14:42:07', '0');
INSERT INTO `sys_menu`
VALUES (1201, '菜单新增', 'sys_menu_add', NULL, 1200, NULL, NULL, '0', '1', '2017-11-08 10:15:53', '2018-09-28 09:07:16',
        '0');
INSERT INTO `sys_menu`
VALUES (1202, '菜单修改', 'sys_menu_edit', NULL, 1200, NULL, NULL, '0', '1', '2017-11-08 10:16:23', '2018-09-28 09:07:18',
        '0');
INSERT INTO `sys_menu`
VALUES (1203, '菜单删除', 'sys_menu_del', NULL, 1200, NULL, NULL, '0', '1', '2017-11-08 10:16:43', '2018-09-28 09:07:22',
        '0');
INSERT INTO `sys_menu`
VALUES (1300, '角色管理', NULL, '/admin/role/index', 1000, 'icon-jiaoseguanli', 3, '0', '0', '2017-11-08 10:13:37',
        '2018-09-28 09:00:48', '0');
INSERT INTO `sys_menu`
VALUES (1301, '角色新增', 'sys_role_add', NULL, 1300, NULL, NULL, '0', '1', '2017-11-08 10:14:18', '2018-09-28 09:07:46',
        '0');
INSERT INTO `sys_menu`
VALUES (1302, '角色修改', 'sys_role_edit', NULL, 1300, NULL, NULL, '0', '1', '2017-11-08 10:14:41', '2018-09-28 09:07:49',
        '0');
INSERT INTO `sys_menu`
VALUES (1303, '角色删除', 'sys_role_del', NULL, 1300, NULL, NULL, '0', '1', '2017-11-08 10:14:59', '2018-09-28 09:07:53',
        '0');
INSERT INTO `sys_menu`
VALUES (1304, '分配权限', 'sys_role_perm', NULL, 1300, NULL, NULL, '0', '1', '2018-04-20 07:22:55', '2018-09-28 09:13:23',
        '0');
INSERT INTO `sys_menu`
VALUES (1400, '部门管理', NULL, '/admin/dept/index', 1000, 'icon-web-icon-', 4, '0', '0', '2018-01-20 13:17:19',
        '2018-12-09 16:35:12', '0');
INSERT INTO `sys_menu`
VALUES (1401, '部门新增', 'sys_dept_add', NULL, 1400, NULL, NULL, '0', '1', '2018-01-20 14:56:16', '2018-09-28 09:08:13',
        '0');
INSERT INTO `sys_menu`
VALUES (1402, '部门修改', 'sys_dept_edit', NULL, 1400, NULL, NULL, '0', '1', '2018-01-20 14:56:59', '2018-09-28 09:08:16',
        '0');
INSERT INTO `sys_menu`
VALUES (1403, '部门删除', 'sys_dept_del', NULL, 1400, NULL, NULL, '0', '1', '2018-01-20 14:57:28', '2018-09-28 09:08:18',
        '0');
INSERT INTO `sys_menu`
VALUES (1500, '租户管理', '', '/admin/tenant/index', 1000, 'icon-erji-zuhushouye', 5, '0', '0', '2018-01-20 13:17:19',
        '2019-05-17 15:36:11', '0');
INSERT INTO `sys_menu`
VALUES (1501, '租户新增', 'admin_systenant_add', NULL, 1500, '1', 0, '0', '1', '2018-05-15 21:35:18', '2019-05-17 15:36:34',
        '0');
INSERT INTO `sys_menu`
VALUES (1502, '租户修改', 'admin_systenant_edit', NULL, 1500, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2019-05-17 15:36:53', '0');
INSERT INTO `sys_menu`
VALUES (1503, '租户删除', 'admin_systenant_del', NULL, 1500, '1', 2, '0', '1', '2018-05-15 21:35:18', '2019-05-17 15:37:00',
        '0');
INSERT INTO `sys_menu`
VALUES (2000, '系统管理', NULL, '/admin', -1, 'icon-xitongguanli', 1, '0', '0', '2017-11-07 20:56:00',
        '2018-09-28 08:53:18', '0');
INSERT INTO `sys_menu`
VALUES (2100, '日志管理', NULL, '/admin/log/index', 2000, 'icon-rizhiguanli', 5, '0', '0', '2017-11-20 14:06:22',
        '2018-09-28 09:01:52', '0');
INSERT INTO `sys_menu`
VALUES (2101, '日志删除', 'sys_log_del', NULL, 2100, NULL, NULL, '0', '1', '2017-11-20 20:37:37', '2018-09-28 09:08:44',
        '0');
INSERT INTO `sys_menu`
VALUES (2200, '字典管理', NULL, '/admin/dict/index', 2000, 'icon-navicon-zdgl', 6, '0', '0', '2017-11-29 11:30:52',
        '2018-09-28 09:01:47', '0');
INSERT INTO `sys_menu`
VALUES (2201, '字典删除', 'sys_dict_del', NULL, 2200, NULL, NULL, '0', '1', '2017-11-29 11:30:11', '2018-09-28 09:09:10',
        '0');
INSERT INTO `sys_menu`
VALUES (2202, '字典新增', 'sys_dict_add', NULL, 2200, NULL, NULL, '0', '1', '2018-05-11 22:34:55', '2018-09-28 09:09:12',
        '0');
INSERT INTO `sys_menu`
VALUES (2203, '字典修改', 'sys_dict_edit', NULL, 2200, NULL, NULL, '0', '1', '2018-05-11 22:36:03', '2018-09-28 09:09:16',
        '0');
INSERT INTO `sys_menu`
VALUES (2210, '参数管理', NULL, '/admin/param/index', 2000, 'icon-canshu', 7, '1', '0', '2019-04-29 22:16:50',
        '2019-06-24 14:52:00', '0');
INSERT INTO `sys_menu`
VALUES (2211, '参数新增', 'admin_syspublicparam_add', NULL, 2210, NULL, 1, '0', '1', '2019-04-29 22:17:36', NULL, '0');
INSERT INTO `sys_menu`
VALUES (2212, '参数删除', 'admin_syspublicparam_del', NULL, 2210, NULL, 1, '0', '1', '2019-04-29 22:17:55', NULL, '0');
INSERT INTO `sys_menu`
VALUES (2213, '参数编辑', 'admin_syspublicparam_edit', NULL, 2210, NULL, 1, '0', '1', '2019-04-29 22:18:14',
        '2019-04-29 22:19:25', '0');
INSERT INTO `sys_menu`
VALUES (2300, '代码生成', '', '/gen/index', 10006, 'icon-weibiaoti46', 1, '0', '0', '2018-01-20 13:17:19',
        '2019-08-12 10:28:44', '0');
INSERT INTO `sys_menu`
VALUES (2400, '终端管理', '', '/admin/client/index', 2000, 'icon-shouji', 9, '0', '0', '2018-01-20 13:17:19',
        '2018-09-28 09:01:43', '0');
INSERT INTO `sys_menu`
VALUES (2401, '客户端新增', 'sys_client_add', NULL, 2400, '1', NULL, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:10:25',
        '0');
INSERT INTO `sys_menu`
VALUES (2402, '客户端修改', 'sys_client_edit', NULL, 2400, NULL, NULL, '0', '1', '2018-05-15 21:37:06',
        '2018-09-28 09:10:27', '0');
INSERT INTO `sys_menu`
VALUES (2403, '客户端删除', 'sys_client_del', NULL, 2400, NULL, NULL, '0', '1', '2018-05-15 21:39:16', '2018-09-28 09:10:30',
        '0');
INSERT INTO `sys_menu`
VALUES (2500, '密钥管理', '', '/admin/social/index', 2000, 'icon-miyue', 10, '0', '0', '2018-01-20 13:17:19',
        '2018-09-28 09:01:41', '0');
INSERT INTO `sys_menu`
VALUES (2501, '密钥新增', 'sys_social_details_add', NULL, 2500, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:52:18', '0');
INSERT INTO `sys_menu`
VALUES (2502, '密钥修改', 'sys_social_details_edit', NULL, 2500, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:51:36', '0');
INSERT INTO `sys_menu`
VALUES (2503, '密钥删除', 'sys_social_details_del', NULL, 2500, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:51:30', '0');
INSERT INTO `sys_menu`
VALUES (2600, '令牌管理', NULL, '/admin/token/index', 2000, 'icon-denglvlingpai', 11, '0', '0', '2018-09-04 05:58:41',
        '2018-09-28 09:01:38', '0');
INSERT INTO `sys_menu`
VALUES (2601, '令牌删除', 'sys_token_del', NULL, 2600, NULL, 1, '0', '1', '2018-09-04 05:59:50', '2018-09-28 09:11:24',
        '0');
INSERT INTO `sys_menu`
VALUES (2700, '动态路由', NULL, '/admin/route/index', 2000, 'icon-luyou', 12, '0', '0', '2018-09-04 05:58:41',
        '2019-06-24 15:14:28', '0');
INSERT INTO `sys_menu`
VALUES (2800, 'Quartz管理', '', '/daemon/job-manage/index', 2000, 'icon-guanwangfangwen', 8, '0', '0',
        '2018-01-20 13:17:19', '2019-03-25 13:52:14', '0');
INSERT INTO `sys_menu`
VALUES (2810, '任务新增', 'job_sys_job_add', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:23',
        '0');
INSERT INTO `sys_menu`
VALUES (2820, '任务修改', 'job_sys_job_edit', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:26',
        '0');
INSERT INTO `sys_menu`
VALUES (2830, '任务删除', 'job_sys_job_del', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18', '2019-03-25 11:50:30',
        '0');
INSERT INTO `sys_menu`
VALUES (2840, '任务暂停', 'job_sys_job_shutdown_job', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:50:18', '0');
INSERT INTO `sys_menu`
VALUES (2850, '任务开始', 'job_sys_job_start_job', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:50:35', '0');
INSERT INTO `sys_menu`
VALUES (2860, '任务刷新', 'job_sys_job_refresh_job', NULL, 2800, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2019-03-25 11:50:39', '0');
INSERT INTO `sys_menu`
VALUES (2870, '执行任务', 'job_sys_job_run_job', NULL, 2800, '1', 0, '0', '1', '2019-08-08 15:35:18', '2019-08-08 15:50:35',
        '0');
INSERT INTO `sys_menu`
VALUES (3000, '系统监控', NULL, '/daemon', -1, 'icon-msnui-supervise', 2, '0', '0', '2018-07-27 01:13:21',
        '2018-09-28 08:53:24', '0');
INSERT INTO `sys_menu`
VALUES (3100, '服务监控', NULL, 'http://127.0.0.1:5001', 3000, 'icon-server', 0, '0', '0', '2018-06-26 10:50:32',
        '2019-05-01 23:54:05', '0');
INSERT INTO `sys_menu`
VALUES (3110, '缓存监控', NULL, '/monitor/redis/index', 3000, 'icon-qingchuhuancun', 1, '1', '0', '2019-05-08 23:51:27',
        '2019-06-24 15:17:45', '0');
INSERT INTO `sys_menu`
VALUES (3200, '接口文档', NULL, 'http://127.0.0.1:9999/swagger-ui.html', 3000, 'icon-wendang', 1, '0', '0',
        '2018-06-26 10:50:32', '2019-05-01 23:57:11', '0');
INSERT INTO `sys_menu`
VALUES (3300, '事务监控', NULL, '/tx/index', 3000, 'icon-gtsquanjushiwufuwuGTS', 5, '0', '0', '2018-08-19 11:02:39',
        '2019-06-24 15:18:04', '0');
INSERT INTO `sys_menu`
VALUES (3400, '在线事务', NULL, '/tx/model', 3000, 'icon-online', 6, '0', '0', '2018-08-19 11:32:04', '2019-06-24 15:18:13',
        '0');
INSERT INTO `sys_menu`
VALUES (3500, '文档扩展', NULL, 'http://127.0.0.1:9999/doc.html', 3000, 'icon-wendang', 2, '0', '0', '2018-06-26 10:50:32',
        '2019-05-01 23:57:42', '0');
INSERT INTO `sys_menu`
VALUES (3600, '任务轨迹', '', '/daemon/status-trace-log/index', 3000, 'icon-guiji', 8, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 15:18:41', '0');
INSERT INTO `sys_menu`
VALUES (3601, '删除轨迹', 'daemon_status_trace_log_del', NULL, 3600, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2019-03-30 09:31:06', '0');
INSERT INTO `sys_menu`
VALUES (3620, 'Quartz日志', '', '/daemon/job-log/index', 3000, 'icon-gtsquanjushiwufuwuGTS', 8, '0', '0',
        '2018-01-20 13:17:19', '2019-06-24 15:18:54', '0');
INSERT INTO `sys_menu`
VALUES (3630, '任务日志', '', '/daemon/execution-log/index', 3000, 'icon-wendang', 7, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 15:19:07', '0');
INSERT INTO `sys_menu`
VALUES (3631, '删除日志', 'daemon_execution_log_del', NULL, 3900, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2019-03-30 09:30:45', '0');
INSERT INTO `sys_menu`
VALUES (3700, '注册配置', NULL, '', 3000, 'icon-line', 10, '0', '0', '2018-01-25 11:08:52', '2019-06-24 15:35:10', '1');
INSERT INTO `sys_menu`
VALUES (4000, '协同管理', NULL, '/activti', -1, 'icon-kuaisugongzuoliu_o', 3, '0', '0', '2018-09-26 01:38:13',
        '2018-09-28 08:58:24', '0');
INSERT INTO `sys_menu`
VALUES (4100, '模型管理', NULL, '/activiti/index', 4000, 'icon-weibiaoti13', 1, '0', '0', '2018-09-26 01:39:07',
        '2019-06-24 15:20:00', '0');
INSERT INTO `sys_menu`
VALUES (4101, '模型管理', 'act_model_manage', NULL, 4100, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07',
        '0');
INSERT INTO `sys_menu`
VALUES (4200, '流程管理', '/activiti/process', '/activiti/process', 4000, 'icon-liucheng', 2, '0', '0',
        '2018-09-26 06:41:05', '2019-06-24 08:31:07', '0');
INSERT INTO `sys_menu`
VALUES (4201, '流程管理', 'act_process_manage', NULL, 4200, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07',
        '0');
INSERT INTO `sys_menu`
VALUES (4300, '请假管理', '/activiti/leave', '/activiti/leave', 4000, 'icon-qingjia', 3, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 08:31:11', '0');
INSERT INTO `sys_menu`
VALUES (4301, '请假新增', 'act_leavebill_add', NULL, 4300, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07',
        '0');
INSERT INTO `sys_menu`
VALUES (4302, '请假修改', 'act_leavebill_edit', NULL, 4300, '1', 1, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:09',
        '0');
INSERT INTO `sys_menu`
VALUES (4303, '请假删除', 'act_leavebill_del', NULL, 4300, '1', 2, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:14',
        '0');
INSERT INTO `sys_menu`
VALUES (4400, '待办任务', '/activiti/task', '/activiti/task', 4000, 'icon-renwu', 4, '0', '0', '2018-09-27 09:52:31',
        '2019-06-24 08:31:18', '0');
INSERT INTO `sys_menu`
VALUES (4401, '流程管理', 'act_task_manage', NULL, 4400, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-09-28 09:12:07',
        '0');
INSERT INTO `sys_menu`
VALUES (5000, '支付管理', NULL, '/pay', -1, 'icon-pay6zhifu', 4, '1', '0', '2019-05-30 15:28:03', '2019-06-20 16:13:23',
        '0');
INSERT INTO `sys_menu`
VALUES (5100, '渠道管理', NULL, '/pay/paychannel/index', 5000, 'icon-zhifuqudaoguanli', 1, '1', '0', '2019-05-30 15:32:17',
        '2019-05-30 19:43:27', '0');
INSERT INTO `sys_menu`
VALUES (5110, '增加渠道', 'pay_paychannel_add', NULL, 5100, NULL, 1, '0', '1', '2019-05-30 15:46:14', NULL, '0');
INSERT INTO `sys_menu`
VALUES (5120, '编辑渠道', 'pay_paychannel_edit', NULL, 5100, NULL, 1, '0', '1', '2019-05-30 15:46:35', NULL, '0');
INSERT INTO `sys_menu`
VALUES (5130, '删除渠道', 'pay_paychannel_del', NULL, 5100, NULL, 1, '0', '1', '2019-05-30 15:47:08', NULL, '0');
INSERT INTO `sys_menu`
VALUES (5200, '收银台', NULL, '/pay/cd/index', 5000, 'icon-shouyintai', 0, '1', '0', '2019-05-30 19:44:00',
        '2019-05-30 19:45:05', '0');
INSERT INTO `sys_menu`
VALUES (5300, '商品订单', '', '/pay/goods/index', 5000, 'icon-dingdan', 2, '0', '0', '2018-01-20 13:17:19',
        '2019-06-16 18:02:21', '0');
INSERT INTO `sys_menu`
VALUES (5310, '商品订单新增', 'generator_paygoodsorder_add', NULL, 5300, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5320, '商品订单修改', 'generator_paygoodsorder_edit', NULL, 5300, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5330, '商品订单删除', 'generator_paygoodsorder_del', NULL, 5300, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5400, '支付订单', '', '/pay/orders/index', 5000, 'icon-zhifu', 3, '0', '0', '2018-01-20 13:17:19',
        '2019-06-16 18:02:06', '0');
INSERT INTO `sys_menu`
VALUES (5410, '支付订单新增', 'generator_paytradeorder_add', NULL, 5400, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5420, '支付订单修改', 'generator_paytradeorder_edit', NULL, 5400, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5430, '支付订单删除', 'generator_paytradeorder_del', NULL, 5400, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5500, '回调记录', '', '/pay/notify/index', 5000, 'icon-huitiao', 4, '0', '0', '2018-01-20 13:17:19',
        '2019-06-16 18:01:49', '0');
INSERT INTO `sys_menu`
VALUES (5510, '记录新增', 'generator_paynotifyrecord_add', NULL, 5500, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5520, '记录修改', 'generator_paynotifyrecord_edit', NULL, 5500, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (5530, '记录删除', 'generator_paynotifyrecord_del', NULL, 5500, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (6000, '微信管理', NULL, '/mp', -1, 'icon-gongzhonghao', 4, '0', '0', '2018-09-26 01:38:13', '2018-09-28 08:58:24',
        '0');
INSERT INTO `sys_menu`
VALUES (6100, '账号管理', '', '/mp/wxaccount/index', 6000, 'icon-weixincaidan', 8, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 15:24:36', '0');
INSERT INTO `sys_menu`
VALUES (6101, '公众号新增', 'mp_wxaccount_add', '', 6100, '1', 0, '0', '1', '2018-05-15 21:35:18', '2019-06-24 15:24:33',
        '0');
INSERT INTO `sys_menu`
VALUES (6102, '公众号修改', 'mp_wxaccount_edit', NULL, 6100, '1', 1, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6103, '公众号删除', 'mp_wxaccount_del', NULL, 6100, '1', 2, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6200, '粉丝管理', '', '/mp/wxaccountfans/index', 6000, 'icon-fensiguanli', 8, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 15:24:46', '0');
INSERT INTO `sys_menu`
VALUES (6201, '粉丝新增', 'mp_wxaccountfans_add', NULL, 6200, '1', 0, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (6202, '粉丝修改', 'mp_wxaccountfans_edit', NULL, 6200, '1', 1, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (6203, '粉丝删除', 'mp_wxaccountfans_del', NULL, 6200, '1', 2, '0', '1', '2018-05-15 21:35:18',
        '2018-07-29 13:38:59', '0');
INSERT INTO `sys_menu`
VALUES (6300, '消息管理', '', '/mp/wxfansmsg/index', 6000, 'icon-xiaoxiguanli', 8, '0', '0', '2018-01-20 13:17:19',
        '2019-06-24 15:24:57', '0');
INSERT INTO `sys_menu`
VALUES (6301, '消息新增', 'mp_wxfansmsg_add', NULL, 6300, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6302, '消息修改', 'mp_wxfansmsg_edit', NULL, 6300, '1', 1, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6303, '消息删除', 'mp_wxfansmsg_del', NULL, 6300, '1', 2, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6304, '消息回复', 'mp_wxfansmsgres_add', NULL, 6300, '1', 3, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (6305, '回复删除', 'mp_wxfansmsgres_del', NULL, 6300, NULL, 1, '0', '1', '2019-03-28 22:53:49', NULL, '0');
INSERT INTO `sys_menu`
VALUES (6400, '菜单设置', NULL, '/mp/wxmenu/index', 6000, 'icon-anniu_weixincaidanlianjie', 6, '1', '0',
        '2019-03-29 15:20:12', '2019-06-24 15:25:07', '0');
INSERT INTO `sys_menu`
VALUES (6401, '保存', 'mp_wxmenu_add', NULL, 6400, NULL, 1, '0', '1', '2019-03-29 15:43:22', '2019-03-29 15:43:30', '0');
INSERT INTO `sys_menu`
VALUES (6402, '发布', 'mp_wxmenu_push', NULL, 6400, NULL, 1, '0', '1', '2019-03-29 15:43:54', NULL, '0');
INSERT INTO `sys_menu`
VALUES (6500, '运营数据', NULL, '/mp/wxstatistics/index', 6000, 'icon-zhexiantu', 7, '1', '0', '2019-04-14 00:15:35',
        '2019-06-24 15:25:15', '0');
INSERT INTO `sys_menu`
VALUES (10000, '文件管理', NULL, '/admin/file/index', 2000, 'icon-wenjianguanli', 6, '1', '0', '2019-06-25 12:44:46', NULL,
        '0');
INSERT INTO `sys_menu`
VALUES (10001, '删除文件', 'sys_file_del', NULL, 10000, NULL, 1, '0', '1', '2019-06-25 13:41:41', NULL, '0');
INSERT INTO `sys_menu`
VALUES (10002, '表单管理', '', '/gen/form', 10006, 'icon-record', 3, '0', '0', '2018-01-20 13:17:19', '2019-08-12 09:36:09',
        '0');
INSERT INTO `sys_menu`
VALUES (10003, '表单新增', 'gen_form_add', NULL, 10002, '1', 0, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (10004, '表单修改', 'gen_form_edit', NULL, 10002, '1', 1, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (10005, '表单删除', 'gen_form_del', NULL, 10002, '1', 2, '0', '1', '2018-05-15 21:35:18', '2018-07-29 13:38:59',
        '0');
INSERT INTO `sys_menu`
VALUES (10006, '开发平台', NULL, '/gen', -1, 'icon-shejiyukaifa-', 9, '1', '0', '2019-08-12 09:35:16',
        '2019-08-12 10:28:35', '0');
INSERT INTO `sys_menu`
VALUES (10007, '数据源管理', NULL, '/gen/datasource', 10006, 'icon-mysql', 0, '1', '0', '2019-08-12 09:42:11',
        '2019-08-12 10:33:30', '0');
INSERT INTO `sys_menu`
VALUES (10008, '表单设计', NULL, '/gen/design', 10006, 'icon-biaodanbiaoqian', 2, '1', '0', '2019-08-16 10:08:56', NULL,
        '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_oauth_client_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_oauth_client_details`;
CREATE TABLE `sys_oauth_client_details`
(
    `client_id`               varchar(32) NOT NULL,
    `resource_ids`            varchar(256)         DEFAULT NULL,
    `client_secret`           varchar(256)         DEFAULT NULL,
    `scope`                   varchar(256)         DEFAULT NULL,
    `authorized_grant_types`  varchar(256)         DEFAULT NULL,
    `web_server_redirect_uri` varchar(256)         DEFAULT NULL,
    `authorities`             varchar(256)         DEFAULT NULL,
    `access_token_validity`   int(11)              DEFAULT NULL,
    `refresh_token_validity`  int(11)              DEFAULT NULL,
    `additional_information`  varchar(4096)        DEFAULT NULL,
    `autoapprove`             varchar(256)         DEFAULT NULL,
    `tenant_id`               int(11)     NOT NULL DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`client_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='终端信息表';

-- ----------------------------
-- Records of sys_oauth_client_details
-- ----------------------------
BEGIN;
INSERT INTO `sys_oauth_client_details`
VALUES ('app', NULL, 'app', 'server', 'password,refresh_token,authorization_code,client_credentials,implicit', NULL,
        NULL, 43200, 2592001, NULL, 'true', 1);
INSERT INTO `sys_oauth_client_details`
VALUES ('daemon', NULL, 'daemon', 'server', 'password,refresh_token', NULL, NULL, NULL, NULL, NULL, 'true', 1);
INSERT INTO `sys_oauth_client_details`
VALUES ('gen', NULL, 'gen', 'server', 'password,refresh_token', NULL, NULL, NULL, NULL, NULL, 'true', 1);
INSERT INTO `sys_oauth_client_details`
VALUES ('mp', NULL, 'mp', 'server', 'password,refresh_token', NULL, NULL, NULL, NULL, NULL, 'true', 1);
INSERT INTO `sys_oauth_client_details`
VALUES ('pig', NULL, 'pig', 'server', 'password,refresh_token,authorization_code,client_credentials',
        'http://localhost:4040/sso1/login,http://localhost:4041/sso1/login,http://localhost:8080/renren-admin/sys/oauth2-sso,http://localhost:8090/sys/oauth2-sso',
        NULL, NULL, NULL, NULL, 'false', 1);
INSERT INTO `sys_oauth_client_details`
VALUES ('qwe', NULL, 'qwe', 'qwe', 'implicit', NULL, NULL, NULL, NULL, NULL, 'false', 0);
INSERT INTO `sys_oauth_client_details`
VALUES ('test', NULL, 'test', 'server', 'password,refresh_token', NULL, NULL, NULL, NULL, NULL, 'true', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_public_param
-- ----------------------------
DROP TABLE IF EXISTS `sys_public_param`;
CREATE TABLE `sys_public_param`
(
    `public_id`     bigint(20) NOT NULL AUTO_INCREMENT COMMENT '编号',
    `public_name`   varchar(128)        DEFAULT NULL,
    `public_key`    varchar(128)        DEFAULT NULL,
    `public_value`  varchar(128)        DEFAULT NULL,
    `status`        char(1)             DEFAULT '0',
    `validate_code` varchar(64)         DEFAULT NULL,
    `create_time`   timestamp  NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`   timestamp  NULL     DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `public_type`   char(1)             DEFAULT '0',
    `system`        char(1)             DEFAULT '0',
    `del_flag`      char(1)             DEFAULT '0',
    `tenant_id`     int(11)             DEFAULT NULL COMMENT '租户ID',
    PRIMARY KEY (`public_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='公共参数配置表';

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role`
(
    `role_id`     int(11)   NOT NULL AUTO_INCREMENT,
    `role_name`   varchar(64)        DEFAULT NULL,
    `role_code`   varchar(64)        DEFAULT NULL,
    `role_desc`   varchar(255)       DEFAULT NULL,
    `ds_type`     char(1)            DEFAULT '2',
    `ds_scope`    varchar(255)       DEFAULT NULL,
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP,
    `update_time` timestamp NULL     DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP,
    `del_flag`    char(1)            DEFAULT '0',
    `tenant_id`   int(11)            DEFAULT NULL,
    PRIMARY KEY (`role_id`) USING BTREE,
    KEY `role_idx1_role_code` (`role_code`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 2
  DEFAULT CHARSET = utf8mb4 COMMENT ='系统角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role`
VALUES (1, '管理员', 'ROLE_ADMIN', '管理员', '3', '2', '2017-10-29 15:45:51', '2018-12-26 14:09:11', '0', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_role_menu
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_menu`;
CREATE TABLE `sys_role_menu`
(
    `role_id` int(11) NOT NULL COMMENT '角色ID',
    `menu_id` int(11) NOT NULL COMMENT '菜单ID',
    PRIMARY KEY (`role_id`, `menu_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='角色菜单表';

-- ----------------------------
-- Records of sys_role_menu
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_menu`
VALUES (1, 1000);
INSERT INTO `sys_role_menu`
VALUES (1, 1100);
INSERT INTO `sys_role_menu`
VALUES (1, 1101);
INSERT INTO `sys_role_menu`
VALUES (1, 1102);
INSERT INTO `sys_role_menu`
VALUES (1, 1103);
INSERT INTO `sys_role_menu`
VALUES (1, 1200);
INSERT INTO `sys_role_menu`
VALUES (1, 1201);
INSERT INTO `sys_role_menu`
VALUES (1, 1202);
INSERT INTO `sys_role_menu`
VALUES (1, 1203);
INSERT INTO `sys_role_menu`
VALUES (1, 1300);
INSERT INTO `sys_role_menu`
VALUES (1, 1301);
INSERT INTO `sys_role_menu`
VALUES (1, 1302);
INSERT INTO `sys_role_menu`
VALUES (1, 1303);
INSERT INTO `sys_role_menu`
VALUES (1, 1304);
INSERT INTO `sys_role_menu`
VALUES (1, 1400);
INSERT INTO `sys_role_menu`
VALUES (1, 1401);
INSERT INTO `sys_role_menu`
VALUES (1, 1402);
INSERT INTO `sys_role_menu`
VALUES (1, 1403);
INSERT INTO `sys_role_menu`
VALUES (1, 1500);
INSERT INTO `sys_role_menu`
VALUES (1, 1501);
INSERT INTO `sys_role_menu`
VALUES (1, 1502);
INSERT INTO `sys_role_menu`
VALUES (1, 1503);
INSERT INTO `sys_role_menu`
VALUES (1, 2000);
INSERT INTO `sys_role_menu`
VALUES (1, 2100);
INSERT INTO `sys_role_menu`
VALUES (1, 2101);
INSERT INTO `sys_role_menu`
VALUES (1, 2200);
INSERT INTO `sys_role_menu`
VALUES (1, 2201);
INSERT INTO `sys_role_menu`
VALUES (1, 2202);
INSERT INTO `sys_role_menu`
VALUES (1, 2203);
INSERT INTO `sys_role_menu`
VALUES (1, 2210);
INSERT INTO `sys_role_menu`
VALUES (1, 2211);
INSERT INTO `sys_role_menu`
VALUES (1, 2212);
INSERT INTO `sys_role_menu`
VALUES (1, 2213);
INSERT INTO `sys_role_menu`
VALUES (1, 2300);
INSERT INTO `sys_role_menu`
VALUES (1, 2400);
INSERT INTO `sys_role_menu`
VALUES (1, 2401);
INSERT INTO `sys_role_menu`
VALUES (1, 2402);
INSERT INTO `sys_role_menu`
VALUES (1, 2403);
INSERT INTO `sys_role_menu`
VALUES (1, 2500);
INSERT INTO `sys_role_menu`
VALUES (1, 2501);
INSERT INTO `sys_role_menu`
VALUES (1, 2502);
INSERT INTO `sys_role_menu`
VALUES (1, 2503);
INSERT INTO `sys_role_menu`
VALUES (1, 2600);
INSERT INTO `sys_role_menu`
VALUES (1, 2601);
INSERT INTO `sys_role_menu`
VALUES (1, 2700);
INSERT INTO `sys_role_menu`
VALUES (1, 2800);
INSERT INTO `sys_role_menu`
VALUES (1, 2810);
INSERT INTO `sys_role_menu`
VALUES (1, 2820);
INSERT INTO `sys_role_menu`
VALUES (1, 2830);
INSERT INTO `sys_role_menu`
VALUES (1, 2840);
INSERT INTO `sys_role_menu`
VALUES (1, 2850);
INSERT INTO `sys_role_menu`
VALUES (1, 2860);
INSERT INTO `sys_role_menu`
VALUES (1, 2870);
INSERT INTO `sys_role_menu`
VALUES (1, 3000);
INSERT INTO `sys_role_menu`
VALUES (1, 3100);
INSERT INTO `sys_role_menu`
VALUES (1, 3110);
INSERT INTO `sys_role_menu`
VALUES (1, 3200);
INSERT INTO `sys_role_menu`
VALUES (1, 3300);
INSERT INTO `sys_role_menu`
VALUES (1, 3400);
INSERT INTO `sys_role_menu`
VALUES (1, 3500);
INSERT INTO `sys_role_menu`
VALUES (1, 3600);
INSERT INTO `sys_role_menu`
VALUES (1, 3601);
INSERT INTO `sys_role_menu`
VALUES (1, 3620);
INSERT INTO `sys_role_menu`
VALUES (1, 3630);
INSERT INTO `sys_role_menu`
VALUES (1, 4000);
INSERT INTO `sys_role_menu`
VALUES (1, 4100);
INSERT INTO `sys_role_menu`
VALUES (1, 4101);
INSERT INTO `sys_role_menu`
VALUES (1, 4200);
INSERT INTO `sys_role_menu`
VALUES (1, 4201);
INSERT INTO `sys_role_menu`
VALUES (1, 4300);
INSERT INTO `sys_role_menu`
VALUES (1, 4301);
INSERT INTO `sys_role_menu`
VALUES (1, 4302);
INSERT INTO `sys_role_menu`
VALUES (1, 4303);
INSERT INTO `sys_role_menu`
VALUES (1, 4400);
INSERT INTO `sys_role_menu`
VALUES (1, 4401);
INSERT INTO `sys_role_menu`
VALUES (1, 5000);
INSERT INTO `sys_role_menu`
VALUES (1, 5100);
INSERT INTO `sys_role_menu`
VALUES (1, 5110);
INSERT INTO `sys_role_menu`
VALUES (1, 5120);
INSERT INTO `sys_role_menu`
VALUES (1, 5130);
INSERT INTO `sys_role_menu`
VALUES (1, 5200);
INSERT INTO `sys_role_menu`
VALUES (1, 5300);
INSERT INTO `sys_role_menu`
VALUES (1, 5310);
INSERT INTO `sys_role_menu`
VALUES (1, 5320);
INSERT INTO `sys_role_menu`
VALUES (1, 5330);
INSERT INTO `sys_role_menu`
VALUES (1, 5400);
INSERT INTO `sys_role_menu`
VALUES (1, 5410);
INSERT INTO `sys_role_menu`
VALUES (1, 5420);
INSERT INTO `sys_role_menu`
VALUES (1, 5430);
INSERT INTO `sys_role_menu`
VALUES (1, 5500);
INSERT INTO `sys_role_menu`
VALUES (1, 5510);
INSERT INTO `sys_role_menu`
VALUES (1, 5520);
INSERT INTO `sys_role_menu`
VALUES (1, 5530);
INSERT INTO `sys_role_menu`
VALUES (1, 6000);
INSERT INTO `sys_role_menu`
VALUES (1, 6100);
INSERT INTO `sys_role_menu`
VALUES (1, 6101);
INSERT INTO `sys_role_menu`
VALUES (1, 6102);
INSERT INTO `sys_role_menu`
VALUES (1, 6103);
INSERT INTO `sys_role_menu`
VALUES (1, 6200);
INSERT INTO `sys_role_menu`
VALUES (1, 6201);
INSERT INTO `sys_role_menu`
VALUES (1, 6202);
INSERT INTO `sys_role_menu`
VALUES (1, 6203);
INSERT INTO `sys_role_menu`
VALUES (1, 6300);
INSERT INTO `sys_role_menu`
VALUES (1, 6301);
INSERT INTO `sys_role_menu`
VALUES (1, 6302);
INSERT INTO `sys_role_menu`
VALUES (1, 6303);
INSERT INTO `sys_role_menu`
VALUES (1, 6304);
INSERT INTO `sys_role_menu`
VALUES (1, 6305);
INSERT INTO `sys_role_menu`
VALUES (1, 6400);
INSERT INTO `sys_role_menu`
VALUES (1, 6401);
INSERT INTO `sys_role_menu`
VALUES (1, 6402);
INSERT INTO `sys_role_menu`
VALUES (1, 6500);
INSERT INTO `sys_role_menu`
VALUES (1, 10000);
INSERT INTO `sys_role_menu`
VALUES (1, 10001);
INSERT INTO `sys_role_menu`
VALUES (1, 10002);
INSERT INTO `sys_role_menu`
VALUES (1, 10003);
INSERT INTO `sys_role_menu`
VALUES (1, 10004);
INSERT INTO `sys_role_menu`
VALUES (1, 10005);
INSERT INTO `sys_role_menu`
VALUES (1, 10006);
INSERT INTO `sys_role_menu`
VALUES (1, 10007);
INSERT INTO `sys_role_menu`
VALUES (1, 10008);
COMMIT;

-- ----------------------------
-- Table structure for sys_route_conf
-- ----------------------------
DROP TABLE IF EXISTS `sys_route_conf`;
CREATE TABLE `sys_route_conf`
(
    `id`          int(11) NOT NULL AUTO_INCREMENT COMMENT '主键',
    `route_name`  varchar(30) DEFAULT NULL,
    `route_id`    varchar(30) DEFAULT NULL,
    `predicates`  json        DEFAULT NULL COMMENT '断言',
    `filters`     json        DEFAULT NULL COMMENT '过滤器',
    `uri`         varchar(50) DEFAULT NULL,
    `order`       int(2)      DEFAULT '0' COMMENT '排序',
    `create_time` datetime    DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` datetime    DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `del_flag`    char(1)     DEFAULT '0',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 13
  DEFAULT CHARSET = utf8mb4 COMMENT ='路由配置表';

-- ----------------------------
-- Records of sys_route_conf
-- ----------------------------
BEGIN;
INSERT INTO `sys_route_conf`
VALUES (1, '工作流管理模块', 'mes-oa-platform', '[
  {
    \"args\": {
      \"_genkey_0\": \"/act/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-oa-platform', 0, '2019-10-16 16:44:41', '2019-11-05 22:36:56', '0');
INSERT INTO `sys_route_conf`
VALUES (2, '认证中心', 'mes-auth', '[
  {
    \"args\": {
      \"_genkey_0\": \"/auth/**\"
    },
    \"name\": \"Path\"
  }
]', '[
  {
    \"args\": {},
    \"name\": \"ValidateCodeGatewayFilter\"
  },
  {
    \"args\": {},
    \"name\": \"PasswordDecoderFilter\"
  }
]', 'lb://mes-auth', 0, '2019-10-16 16:44:41', '2019-11-05 22:36:57', '0');
INSERT INTO `sys_route_conf`
VALUES (3, '代码生成模块', 'mes-codegen', '[
  {
    \"args\": {
      \"_genkey_0\": \"/gen/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-codegen', 0, '2019-10-16 16:44:41', '2019-11-05 22:36:58', '0');
INSERT INTO `sys_route_conf`
VALUES (4, 'elastic-job定时任务模块', 'mes-daemon-elastic-job', '[
  {
    \"args\": {
      \"_genkey_0\": \"/daemon/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-daemon-elastic-job', 0, '2019-10-16 16:44:41', '2019-11-05 22:36:59', '0');
INSERT INTO `sys_route_conf`
VALUES (5, 'quartz定时任务模块', 'mes-daemon-quartz', '[
  {
    \"args\": {
      \"_genkey_0\": \"/job/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-daemon-quartz', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:02', '0');
INSERT INTO `sys_route_conf`
VALUES (6, '分布式事务模块', 'mes-tx-manager', '[
  {
    \"args\": {
      \"_genkey_0\": \"/tx/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-tx-manager', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:04', '0');
INSERT INTO `sys_route_conf`
VALUES (7, '通用权限模块', 'mes-upms-biz', '[
  {
    \"args\": {
      \"_genkey_0\": \"/admin/**\"
    },
    \"name\": \"Path\"
  }
]', '[
  {
    \"args\": {
      \"key-resolver\": \"#{@remoteAddrKeyResolver}\",
      \"redis-rate-limiter.burstCapacity\": \"1000\",
      \"redis-rate-limiter.replenishRate\": \"1000\"
    },
    \"name\": \"RequestRateLimiter\"
  }
]', 'lb://mes-upms-biz', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:05', '0');
INSERT INTO `sys_route_conf`
VALUES (8, '工作流长链接支持1', 'mes-oa-platform-ws-1', '[
  {
    \"args\": {
      \"_genkey_0\": \"/act/ws/info/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-oa-platform', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:07', '0');
INSERT INTO `sys_route_conf`
VALUES (9, '工作流长链接支持2', 'mes-oa-platform-ws-2', '[
  {
    \"args\": {
      \"_genkey_0\": \"/act/ws/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb:ws://mes-oa-platform', 100, '2019-10-16 16:44:41', '2019-11-05 22:37:09', '0');
INSERT INTO `sys_route_conf`
VALUES (10, '微信公众号管理', 'mes-mp-platform', '[
  {
    \"args\": {
      \"_genkey_0\": \"/mp/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-mp-platform', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:12', '0');
INSERT INTO `sys_route_conf`
VALUES (11, '支付管理', 'mes-pay-platform', '[
  {
    \"args\": {
      \"_genkey_0\": \"/pay/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-pay-platform', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:13', '0');
INSERT INTO `sys_route_conf`
VALUES (12, '监控管理', 'mes-monitor', '[
  {
    \"args\": {
      \"_genkey_0\": \"/monitor/**\"
    },
    \"name\": \"Path\"
  }
]', '[]', 'lb://mes-monitor', 0, '2019-10-16 16:44:41', '2019-11-05 22:37:17', '0');
COMMIT;

-- ----------------------------
-- Table structure for sys_social_details
-- ----------------------------
DROP TABLE IF EXISTS `sys_social_details`;
CREATE TABLE `sys_social_details`
(
    `id`           int(11) NOT NULL AUTO_INCREMENT COMMENT '主鍵',
    `type`         varchar(16)      DEFAULT NULL,
    `remark`       varchar(64)      DEFAULT NULL,
    `app_id`       varchar(64)      DEFAULT NULL,
    `app_secret`   varchar(64)      DEFAULT NULL,
    `redirect_url` varchar(128)     DEFAULT NULL,
    `create_time`  datetime         DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time`  datetime         DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    `del_flag`     char(1)          DEFAULT '0',
    `tenant_id`    int(11) NOT NULL DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 5
  DEFAULT CHARSET = utf8mb4 COMMENT ='系统社交登录账号表';

-- ----------------------------
-- Records of sys_social_details
-- ----------------------------
BEGIN;
INSERT INTO `sys_social_details`
VALUES (1, 'WX', '微信互联参数', 'wxd1678d3f83b1d83a', '6ddb043f94da5d2172926abe8533504f', 'daoweicloud.com',
        '2018-08-16 14:24:25', '2019-03-02 09:43:13', '0', 1);
INSERT INTO `sys_social_details`
VALUES (2, 'GITEE', '码云登录', '8fc54e0e76e7842cf767c3ae3b9fdc48c03cefed27aa565ff7b2a39d142d9892',
        'c544469ce78a67d9fcf9b28cd9f310b73f5cbc46a1b993e0802ad61517deb221',
        'http://gitee.huaxiadaowei.com/#/authredirect', '2019-06-28 09:59:55', '2019-06-28 09:59:55', '0', 1);
INSERT INTO `sys_social_details`
VALUES (3, 'OSC', '开源中国', 'neIIqlwGsjsfsA6uxNqD', 'aOPhRuOOJNXV1x7JrTJ9qIyRCAPXoO0l',
        'http://gitee.huaxiadaowei.com/#/authredirect', '2019-06-28 10:05:37', '2019-06-28 10:05:37', '0', 1);
INSERT INTO `sys_social_details`
VALUES (4, 'MINI', '小程序', 'wx6832be859d0e1cf5', '08036aef810dcb2f8ae31510910ba631', NULL, '2019-11-02 22:08:03',
        '2019-11-02 22:10:53', '0', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_tenant
-- ----------------------------
DROP TABLE IF EXISTS `sys_tenant`;
CREATE TABLE `sys_tenant`
(
    `id`          int(11)   NOT NULL AUTO_INCREMENT COMMENT '租户id',
    `name`        varchar(255)       DEFAULT NULL,
    `code`        varchar(64)        DEFAULT NULL,
    `start_time`  timestamp NULL     DEFAULT NULL COMMENT '开始时间',
    `end_time`    timestamp NULL     DEFAULT NULL COMMENT '结束时间',
    `status`      char(1)            DEFAULT '0',
    `del_flag`    char(1)            DEFAULT '0',
    `create_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建',
    `update_time` timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
    PRIMARY KEY (`id`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 2
  DEFAULT CHARSET = utf8mb4 COMMENT ='租户表';

-- ----------------------------
-- Records of sys_tenant
-- ----------------------------
BEGIN;
INSERT INTO `sys_tenant`
VALUES (1, '北京分公司', '1', '2019-05-15 00:00:00', '2020-05-15 00:00:00', '0', '0', '2019-05-15 15:44:57',
        '2019-05-18 14:47:30');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user`
(
    `user_id`     int(11)   NOT NULL AUTO_INCREMENT COMMENT '主键ID',
    `username`    varchar(64)        DEFAULT NULL,
    `password`    varchar(255)       DEFAULT NULL,
    `salt`        varchar(255)       DEFAULT NULL,
    `phone`       varchar(20)        DEFAULT NULL,
    `avatar`      varchar(255)       DEFAULT NULL,
    `dept_id`     int(11)            DEFAULT NULL COMMENT '部门ID',
    `create_time` timestamp NULL     DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
    `update_time` timestamp NULL     DEFAULT NULL ON UPDATE CURRENT_TIMESTAMP COMMENT '修改时间',
    `lock_flag`   char(1)            DEFAULT '0',
    `del_flag`    char(1)            DEFAULT '0',
    `wx_openid`   varchar(32)        DEFAULT NULL COMMENT '微信登录openId',
    `mini_openid` varchar(32)        DEFAULT NULL COMMENT '小程序openId',
    `qq_openid`   varchar(32)        DEFAULT NULL COMMENT 'QQ openId',
    `gitee_login` varchar(100)       DEFAULT NULL COMMENT '码云 标识',
    `osc_id`      varchar(100)       DEFAULT NULL COMMENT '开源中国 标识',
    `tenant_id`   int(11)   NOT NULL DEFAULT '0' COMMENT '所属租户',
    PRIMARY KEY (`user_id`) USING BTREE,
    KEY `user_wx_openid` (`wx_openid`) USING BTREE,
    KEY `user_qq_openid` (`qq_openid`) USING BTREE,
    KEY `user_idx1_username` (`username`) USING BTREE
) ENGINE = InnoDB
  AUTO_INCREMENT = 2
  DEFAULT CHARSET = utf8mb4 COMMENT ='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user`
VALUES (1, 'admin', '$2a$10$IVzj1Wd.ZQdOIWdb1htQjexU94uoNeuk1crlQ9ExVupPi0Iy1uv.C', '', '17034642888',
        '/admin/sys-file/lengleng/c5a85e0770cd4fe78bc14b63b3bd05ae.jpg', 1, '2018-04-20 07:15:18',
        '2019-11-02 22:12:11', '0', '0', 'o_0FT0uyg_H1vVy2H0JpSwlVGhWQ', 'oBxPy5E-v82xWGsfzZVzkD3wEX64', NULL, 'log4j',
        '2303656', 1);
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role`
(
    `user_id` int(11) NOT NULL COMMENT '用户ID',
    `role_id` int(11) NOT NULL COMMENT '角色ID',
    PRIMARY KEY (`user_id`, `role_id`) USING BTREE
) ENGINE = InnoDB
  DEFAULT CHARSET = utf8mb4 COMMENT ='用户角色表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role`
VALUES (1, 1);
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;